Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 584524 |
| Missing cells | 137396 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 93.7 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Numeric | 7 |
|---|---|
| Categorical | 7 |
| DateTime | 3 |
| Text | 3 |
| Unsupported | 1 |
item_id is highly overall correlated with Customer ID and 3 other fields | High correlation |
price is highly overall correlated with grand_total | High correlation |
grand_total is highly overall correlated with price | High correlation |
Month is highly overall correlated with M-Y | High correlation |
Customer ID is highly overall correlated with item_id and 3 other fields | High correlation |
status is highly overall correlated with BI Status | High correlation |
BI Status is highly overall correlated with status | High correlation |
Year is highly overall correlated with item_id and 3 other fields | High correlation |
M-Y is highly overall correlated with item_id and 4 other fields | High correlation |
FY is highly overall correlated with item_id and 3 other fields | High correlation |
status is highly imbalanced (51.7%) | Imbalance |
sales_commission_code has 137175 (23.5%) missing values | Missing |
qty_ordered is highly skewed (γ1 = 184.7792386) | Skewed |
grand_total is highly skewed (γ1 = 254.9982139) | Skewed |
item_id has unique values | Unique |
increment_id is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
grand_total has 9632 (1.6%) zeros | Zeros |
discount_amount has 376306 (64.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-09-13 12:50:52.871403 |
|---|---|
| Analysis finished | 2023-09-13 12:52:51.750405 |
| Duration | 1 minute and 58.88 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
item_id
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 584524 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 565667.07 |
| Minimum | 211131 |
|---|---|
| Maximum | 905208 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 211131 |
|---|---|
| 5-th percentile | 247522.15 |
| Q1 | 395000.75 |
| median | 568424.5 |
| Q3 | 739106.25 |
| 95-th percentile | 872504.85 |
| Maximum | 905208 |
| Range | 694077 |
| Interquartile range (IQR) | 344105.5 |
Descriptive statistics
| Standard deviation | 200121.17 |
|---|---|
| Coefficient of variation (CV) | 0.35377907 |
| Kurtosis | -1.1845506 |
| Mean | 565667.07 |
| Median Absolute Deviation (MAD) | 171889 |
| Skewness | -0.047515772 |
| Sum | 3.3064598 × 1011 |
| Variance | 4.0048484 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 211131 | 1 | < 0.1% |
| 683031 | 1 | < 0.1% |
| 683022 | 1 | < 0.1% |
| 683023 | 1 | < 0.1% |
| 683030 | 1 | < 0.1% |
| 683029 | 1 | < 0.1% |
| 683033 | 1 | < 0.1% |
| 683032 | 1 | < 0.1% |
| 683035 | 1 | < 0.1% |
| 683026 | 1 | < 0.1% |
| Other values (584514) | 584514 |
| Value | Count | Frequency (%) |
| 211131 | 1 | |
| 211133 | 1 | |
| 211134 | 1 | |
| 211135 | 1 | |
| 211136 | 1 | |
| 211137 | 1 | |
| 211138 | 1 | |
| 211139 | 1 | |
| 211140 | 1 | |
| 211141 | 1 |
| Value | Count | Frequency (%) |
| 905208 | 1 | |
| 905207 | 1 | |
| 905206 | 1 | |
| 905205 | 1 | |
| 905204 | 1 | |
| 905202 | 1 | |
| 905200 | 1 | |
| 905199 | 1 | |
| 905198 | 1 | |
| 905196 | 1 |
status
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
| complete | |
|---|---|
| canceled | |
| received | |
| order_refunded | |
| refund | 8050 |
| Other values (11) | 4706 |
Length
| Max length | 14 |
|---|---|
| Median length | 8 |
| Mean length | 8.5499334 |
| Min length | 2 |
Characters and Unicode
| Total characters | 4997513 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | complete |
|---|---|
| 2nd row | canceled |
| 3rd row | canceled |
| 4th row | complete |
| 5th row | order_refunded |
Common Values
| Value | Count | Frequency (%) |
| complete | 233685 | |
| canceled | 201249 | |
| received | 77290 | 13.2% |
| order_refunded | 59529 | 10.2% |
| refund | 8050 | 1.4% |
| cod | 2859 | 0.5% |
| paid | 1159 | 0.2% |
| closed | 494 | 0.1% |
| payment_review | 57 | < 0.1% |
| pending | 48 | < 0.1% |
| Other values (6) | 89 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| complete | 233685 | |
| canceled | 201249 | |
| received | 77290 | 13.2% |
| order_refunded | 59529 | 10.2% |
| refund | 8050 | 1.4% |
| cod | 2859 | 0.5% |
| paid | 1159 | 0.2% |
| closed | 494 | 0.1% |
| payment_review | 57 | < 0.1% |
| pending | 48 | < 0.1% |
| Other values (6) | 89 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1289167 | |
| c | 716863 | |
| d | 469815 | 9.4% |
| l | 435466 | 8.7% |
| o | 296631 | 5.9% |
| n | 269032 | 5.4% |
| r | 264027 | 5.3% |
| p | 235003 | 4.7% |
| m | 233742 | 4.7% |
| t | 233742 | 4.7% |
| Other values (14) | 554025 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4937912 | |
| Connector Punctuation | 59593 | 1.2% |
| Other Punctuation | 4 | < 0.1% |
| Uppercase Letter | 4 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1289167 | |
| c | 716863 | |
| d | 469815 | 9.5% |
| l | 435466 | 8.8% |
| o | 296631 | 6.0% |
| n | 269032 | 5.4% |
| r | 264027 | 5.3% |
| p | 235003 | 4.8% |
| m | 233742 | 4.7% |
| t | 233742 | 4.7% |
| Other values (11) | 494424 | 10.0% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 59593 |
Other Punctuation
| Value | Count | Frequency (%) |
| \ | 4 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4937916 | |
| Common | 59597 | 1.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1289167 | |
| c | 716863 | |
| d | 469815 | 9.5% |
| l | 435466 | 8.8% |
| o | 296631 | 6.0% |
| n | 269032 | 5.4% |
| r | 264027 | 5.3% |
| p | 235003 | 4.8% |
| m | 233742 | 4.7% |
| t | 233742 | 4.7% |
| Other values (12) | 494428 | 10.0% |
Common
| Value | Count | Frequency (%) |
| _ | 59593 | |
| \ | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4997513 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1289167 | |
| c | 716863 | |
| d | 469815 | 9.4% |
| l | 435466 | 8.7% |
| o | 296631 | 5.9% |
| n | 269032 | 5.4% |
| r | 264027 | 5.3% |
| p | 235003 | 4.7% |
| m | 233742 | 4.7% |
| t | 233742 | 4.7% |
| Other values (14) | 554025 |
created_at
Date
| Distinct | 789 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| Minimum | 2016-07-01 00:00:00 |
|---|---|
| Maximum | 2018-08-28 00:00:00 |
sku
Text
| Distinct | 84889 |
|---|---|
| Distinct (%) | 14.5% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
Length
| Max length | 69 |
|---|---|
| Median length | 63 |
| Mean length | 20.254032 |
| Min length | 5 |
Characters and Unicode
| Total characters | 11838563 |
|---|---|
| Distinct characters | 94 |
| Distinct categories | 13 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 38653 ? |
|---|---|
| Unique (%) | 6.6% |
Sample
| 1st row | kreations_YI 06-L |
|---|---|
| 2nd row | kcc_Buy 2 Frey Air Freshener & Get 1 Kasual Body Spray Free |
| 3rd row | Ego_UP0017-999-MR0 |
| 4th row | kcc_krone deal |
| 5th row | BK7010400AG |
| Value | Count | Frequency (%) |
| 17805 | 1.9% | |
| infinix | 5978 | 0.7% |
| halwa | 5418 | 0.6% |
| hot | 4859 | 0.5% |
| black | 4616 | 0.5% |
| one | 4385 | 0.5% |
| of | 4104 | 0.4% |
| matsam59db75adb2f80 | 3775 | 0.4% |
| sohan | 3718 | 0.4% |
| al | 3661 | 0.4% |
| Other values (86322) | 856654 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 765823 | 6.5% |
| 5 | 536900 | 4.5% |
| 0 | 464376 | 3.9% |
| B | 424348 | 3.6% |
| - | 366768 | 3.1% |
| e | 348343 | 2.9% |
| 9 | 348133 | 2.9% |
| 1 | 345339 | 2.9% |
| a | 344867 | 2.9% |
| E | 340693 | 2.9% |
| Other values (84) | 7552973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4517562 | |
| Decimal Number | 3268014 | |
| Lowercase Letter | 3026250 | |
| Dash Punctuation | 366787 | 3.1% |
| Space Separator | 336856 | 2.8% |
| Connector Punctuation | 297722 | 2.5% |
| Other Punctuation | 14679 | 0.1% |
| Open Punctuation | 4520 | < 0.1% |
| Close Punctuation | 4506 | < 0.1% |
| Math Symbol | 1525 | < 0.1% |
| Other values (3) | 142 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 348343 | |
| a | 344867 | |
| i | 247921 | 8.2% |
| o | 208073 | 6.9% |
| l | 201562 | 6.7% |
| r | 200692 | 6.6% |
| n | 195456 | 6.5% |
| t | 166925 | 5.5% |
| s | 143911 | 4.8% |
| c | 121305 | 4.0% |
| Other values (18) | 847195 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 765823 | |
| B | 424348 | 9.4% |
| E | 340693 | 7.5% |
| C | 327481 | 7.2% |
| F | 323007 | 7.2% |
| D | 288921 | 6.4% |
| M | 276654 | 6.1% |
| S | 231839 | 5.1% |
| T | 191365 | 4.2% |
| P | 175903 | 3.9% |
| Other values (17) | 1171528 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 536900 | |
| 0 | 464376 | |
| 9 | 348133 | |
| 1 | 345339 | |
| 2 | 281248 | |
| 3 | 274352 | |
| 7 | 271984 | |
| 4 | 262229 | |
| 6 | 242830 | |
| 8 | 240623 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 5968 | |
| . | 3473 | |
| / | 1987 | 13.5% |
| ' | 1174 | 8.0% |
| , | 922 | 6.3% |
| # | 392 | 2.7% |
| " | 280 | 1.9% |
| : | 251 | 1.7% |
| % | 231 | 1.6% |
| \ | 1 | < 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 1502 | |
| | | 12 | 0.8% |
| = | 9 | 0.6% |
| × | 2 | 0.1% |
Control
| Value | Count | Frequency (%) |
| 12 | ||
| 2 | 13.3% | |
| 1 | 6.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 366768 | |
| – | 19 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 336313 | ||
| 543 | 0.2% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 4495 | |
| [ | 25 | 0.6% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 4481 | |
| ] | 25 | 0.6% |
Other Symbol
| Value | Count | Frequency (%) |
| ° | 3 | |
| ® | 1 | 25.0% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 297722 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 123 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7543812 | |
| Common | 4294751 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 765823 | 10.2% |
| B | 424348 | 5.6% |
| e | 348343 | 4.6% |
| a | 344867 | 4.6% |
| E | 340693 | 4.5% |
| C | 327481 | 4.3% |
| F | 323007 | 4.3% |
| D | 288921 | 3.8% |
| M | 276654 | 3.7% |
| i | 247921 | 3.3% |
| Other values (45) | 3855754 |
Common
| Value | Count | Frequency (%) |
| 5 | 536900 | |
| 0 | 464376 | |
| - | 366768 | |
| 9 | 348133 | |
| 1 | 345339 | |
| 336313 | ||
| _ | 297722 | 6.9% |
| 2 | 281248 | 6.5% |
| 3 | 274352 | 6.4% |
| 7 | 271984 | 6.3% |
| Other values (29) | 771616 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11837950 | |
| None | 594 | < 0.1% |
| Punctuation | 19 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 765823 | 6.5% |
| 5 | 536900 | 4.5% |
| 0 | 464376 | 3.9% |
| B | 424348 | 3.6% |
| - | 366768 | 3.1% |
| e | 348343 | 2.9% |
| 9 | 348133 | 2.9% |
| 1 | 345339 | 2.9% |
| a | 344867 | 2.9% |
| E | 340693 | 2.9% |
| Other values (76) | 7552360 |
None
| Value | Count | Frequency (%) |
| 543 | ||
| è | 20 | 3.4% |
| È | 13 | 2.2% |
| é | 12 | 2.0% |
| ° | 3 | 0.5% |
| × | 2 | 0.3% |
| ® | 1 | 0.2% |
Punctuation
| Value | Count | Frequency (%) |
| – | 19 |
price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 9121 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6348.7475 |
| Minimum | 0 |
|---|---|
| Maximum | 1012625.9 |
| Zeros | 2232 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 95 |
| Q1 | 360 |
| median | 899 |
| Q3 | 4070 |
| 95-th percentile | 29199 |
| Maximum | 1012625.9 |
| Range | 1012625.9 |
| Interquartile range (IQR) | 3710 |
Descriptive statistics
| Standard deviation | 14949.27 |
|---|---|
| Coefficient of variation (CV) | 2.3546801 |
| Kurtosis | 71.248367 |
| Mean | 6348.7475 |
| Median Absolute Deviation (MAD) | 699 |
| Skewness | 5.228716 |
| Sum | 3.7109953 × 109 |
| Variance | 2.2348066 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1000 | 11077 | 1.9% |
| 999 | 10120 | 1.7% |
| 500 | 9215 | 1.6% |
| 699 | 8407 | 1.4% |
| 499 | 7693 | 1.3% |
| 399 | 6999 | 1.2% |
| 299 | 6647 | 1.1% |
| 799 | 6024 | 1.0% |
| 599 | 6008 | 1.0% |
| 899 | 4471 | 0.8% |
| Other values (9111) | 507863 |
| Value | Count | Frequency (%) |
| 0 | 2232 | |
| 0.1 | 15 | < 0.1% |
| 0.11 | 8 | < 0.1% |
| 0.15 | 1 | < 0.1% |
| 0.2 | 16 | < 0.1% |
| 0.8 | 9 | < 0.1% |
| 1 | 1237 | |
| 1.3 | 24 | < 0.1% |
| 1.5 | 20 | < 0.1% |
| 1.6 | 34 | < 0.1% |
| Value | Count | Frequency (%) |
| 1012625.9 | 1 | < 0.1% |
| 515975 | 1 | < 0.1% |
| 479000 | 4 | |
| 330499 | 2 | |
| 320000 | 1 | < 0.1% |
| 307970 | 2 | |
| 300000 | 4 | |
| 291667 | 2 | |
| 289999 | 1 | < 0.1% |
| 265499 | 1 | < 0.1% |
qty_ordered
Real number (ℝ)
SKEWED 
| Distinct | 74 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2963882 |
| Minimum | 1 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 1000 |
| Range | 999 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.9960611 |
|---|---|
| Coefficient of variation (CV) | 3.0824572 |
| Kurtosis | 42587.952 |
| Mean | 1.2963882 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 184.77924 |
| Sum | 757770 |
| Variance | 15.968504 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 505214 | |
| 2 | 46656 | 8.0% |
| 3 | 15406 | 2.6% |
| 5 | 11213 | 1.9% |
| 4 | 4141 | 0.7% |
| 6 | 589 | 0.1% |
| 10 | 292 | < 0.1% |
| 8 | 153 | < 0.1% |
| 7 | 112 | < 0.1% |
| 12 | 95 | < 0.1% |
| Other values (64) | 653 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 505214 | |
| 2 | 46656 | 8.0% |
| 3 | 15406 | 2.6% |
| 4 | 4141 | 0.7% |
| 5 | 11213 | 1.9% |
| 6 | 589 | 0.1% |
| 7 | 112 | < 0.1% |
| 8 | 153 | < 0.1% |
| 9 | 42 | < 0.1% |
| 10 | 292 | < 0.1% |
| Value | Count | Frequency (%) |
| 1000 | 6 | |
| 502 | 1 | < 0.1% |
| 500 | 4 | |
| 380 | 1 | < 0.1% |
| 304 | 1 | < 0.1% |
| 300 | 2 | < 0.1% |
| 200 | 7 | |
| 187 | 1 | < 0.1% |
| 186 | 1 | < 0.1% |
| 185 | 1 | < 0.1% |
grand_total
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 36829 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8530.6186 |
| Minimum | -1594 |
|---|---|
| Maximum | 17888000 |
| Zeros | 9632 |
| Zeros (%) | 1.6% |
| Negative | 76 |
| Negative (%) | < 0.1% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | -1594 |
|---|---|
| 5-th percentile | 160 |
| Q1 | 945 |
| median | 1960.4 |
| Q3 | 6999 |
| 95-th percentile | 34497.65 |
| Maximum | 17888000 |
| Range | 17889594 |
| Interquartile range (IQR) | 6054 |
Descriptive statistics
| Standard deviation | 61320.815 |
|---|---|
| Coefficient of variation (CV) | 7.1883198 |
| Kurtosis | 74191.656 |
| Mean | 8530.6186 |
| Median Absolute Deviation (MAD) | 1461.4 |
| Skewness | 254.99821 |
| Sum | 4.9863513 × 109 |
| Variance | 3.7602423 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9632 | 1.6% |
| 1000 | 5146 | 0.9% |
| 2000 | 3781 | 0.6% |
| 2500 | 3235 | 0.6% |
| 5000 | 2912 | 0.5% |
| 1149 | 2525 | 0.4% |
| 12599 | 2520 | 0.4% |
| 399 | 2459 | 0.4% |
| 4000 | 2387 | 0.4% |
| 150 | 2256 | 0.4% |
| Other values (36819) | 547671 |
| Value | Count | Frequency (%) |
| -1594 | 1 | < 0.1% |
| -1311.5 | 7 | |
| -1106.65 | 1 | < 0.1% |
| -873.4 | 1 | < 0.1% |
| -528 | 1 | < 0.1% |
| -511 | 2 | < 0.1% |
| -425.7 | 2 | < 0.1% |
| -384 | 1 | < 0.1% |
| -340.6 | 16 | |
| -249 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 17888000 | 6 | |
| 1315875 | 1 | < 0.1% |
| 1280473 | 2 | < 0.1% |
| 1279980 | 1 | < 0.1% |
| 1155966 | 1 | < 0.1% |
| 1039479 | 1 | < 0.1% |
| 1028751 | 4 | |
| 1012625.9 | 1 | < 0.1% |
| 888065 | 7 | |
| 847024 | 7 |
increment_id
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
category_name_1
Categorical
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 164 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
| Mobiles & Tablets | |
|---|---|
| Men's Fashion | |
| Women's Fashion | |
| Appliances | |
| Superstore | |
| Other values (11) |
Length
| Max length | 18 |
|---|---|
| Median length | 17 |
| Mean length | 12.839072 |
| Min length | 2 |
Characters and Unicode
| Total characters | 7502640 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Women's Fashion |
|---|---|
| 2nd row | Beauty & Grooming |
| 3rd row | Women's Fashion |
| 4th row | Beauty & Grooming |
| 5th row | Soghaat |
Common Values
| Value | Count | Frequency (%) |
| Mobiles & Tablets | 115710 | |
| Men's Fashion | 92221 | |
| Women's Fashion | 59721 | |
| Appliances | 52413 | |
| Superstore | 43613 | 7.5% |
| Beauty & Grooming | 41496 | 7.1% |
| Soghaat | 34011 | 5.8% |
| Others | 29218 | 5.0% |
| Home & Living | 26504 | 4.5% |
| Entertainment | 26326 | 4.5% |
| Other values (6) | 63127 |
Length
| Value | Count | Frequency (%) |
| 221184 | ||
| fashion | 151942 | |
| mobiles | 115710 | |
| tablets | 115710 | |
| men's | 92221 | 7.8% |
| women's | 59721 | 5.1% |
| appliances | 52413 | 4.4% |
| superstore | 43613 | 3.7% |
| beauty | 41496 | 3.5% |
| grooming | 41496 | 3.5% |
| Other values (14) | 243164 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 696414 | 9.3% |
| e | 690373 | 9.2% |
| 594310 | 7.9% | |
| o | 562102 | 7.5% |
| n | 522686 | 7.0% |
| a | 493383 | 6.6% |
| i | 476800 | 6.4% |
| t | 397441 | 5.3% |
| l | 304813 | 4.1% |
| b | 247914 | 3.3% |
| Other values (29) | 2516404 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5569868 | |
| Uppercase Letter | 957486 | 12.8% |
| Space Separator | 594310 | 7.9% |
| Other Punctuation | 380976 | 5.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 696414 | |
| e | 690373 | |
| o | 562102 | |
| n | 522686 | |
| a | 493383 | |
| i | 476800 | |
| t | 397441 | |
| l | 304813 | 5.5% |
| b | 247914 | 4.5% |
| h | 236151 | 4.2% |
| Other values (10) | 941791 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 207931 | |
| F | 151942 | |
| T | 115710 | |
| S | 98604 | |
| B | 59860 | 6.3% |
| W | 59721 | 6.2% |
| A | 52413 | 5.5% |
| H | 44006 | 4.6% |
| G | 41496 | 4.3% |
| E | 29804 | 3.1% |
| Other values (5) | 95999 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 221184 | |
| ' | 151942 | |
| \ | 7850 | 2.1% |
Space Separator
| Value | Count | Frequency (%) |
| 594310 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6527354 | |
| Common | 975286 | 13.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 696414 | 10.7% |
| e | 690373 | 10.6% |
| o | 562102 | 8.6% |
| n | 522686 | 8.0% |
| a | 493383 | 7.6% |
| i | 476800 | 7.3% |
| t | 397441 | 6.1% |
| l | 304813 | 4.7% |
| b | 247914 | 3.8% |
| h | 236151 | 3.6% |
| Other values (25) | 1899277 |
Common
| Value | Count | Frequency (%) |
| 594310 | ||
| & | 221184 | 22.7% |
| ' | 151942 | 15.6% |
| \ | 7850 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7502640 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 696414 | 9.3% |
| e | 690373 | 9.2% |
| 594310 | 7.9% | |
| o | 562102 | 7.5% |
| n | 522686 | 7.0% |
| a | 493383 | 6.6% |
| i | 476800 | 6.4% |
| t | 397441 | 5.3% |
| l | 304813 | 4.1% |
| b | 247914 | 3.3% |
| Other values (29) | 2516404 |
MISSING 
| Distinct | 7225 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 137175 |
| Missing (%) | 23.5% |
| Memory size | 4.5 MiB |
Length
| Max length | 100 |
|---|---|
| Median length | 2 |
| Mean length | 4.0094088 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1793605 |
|---|---|
| Distinct characters | 88 |
| Distinct categories | 14 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 4 ? |
Unique
| Unique | 3126 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | \N |
|---|---|
| 2nd row | \N |
| 3rd row | \N |
| 4th row | R-FSD-52352 |
| 5th row | \N |
| Value | Count | Frequency (%) |
| n | 339002 | |
| c | 4272 | 0.9% |
| skz | 2807 | 0.6% |
| 40968 | 2711 | 0.6% |
| c-lhc-30667 | 2654 | 0.6% |
| c-lhw-50074 | 2436 | 0.5% |
| r | 2366 | 0.5% |
| cisb30211 | 2334 | 0.5% |
| c-rwp-31924 | 1938 | 0.4% |
| cmux33202 | 1883 | 0.4% |
| Other values (6333) | 100087 | 21.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 339256 | |
| \ | 339001 | |
| - | 147598 | 8.2% |
| 1 | 93561 | 5.2% |
| 0 | 92891 | 5.2% |
| 4 | 79416 | 4.4% |
| 3 | 57271 | 3.2% |
| C | 54301 | 3.0% |
| 2 | 47864 | 2.7% |
| 6 | 45449 | 2.5% |
| Other values (78) | 496997 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 663978 | |
| Decimal Number | 564880 | |
| Other Punctuation | 339781 | |
| Dash Punctuation | 147598 | 8.2% |
| Lowercase Letter | 58671 | 3.3% |
| Space Separator | 15594 | 0.9% |
| Connector Punctuation | 3070 | 0.2% |
| Math Symbol | 22 | < 0.1% |
| Format | 4 | < 0.1% |
| Open Punctuation | 2 | < 0.1% |
| Other values (4) | 5 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 339256 | |
| C | 54301 | 8.2% |
| R | 41488 | 6.2% |
| H | 29441 | 4.4% |
| U | 21270 | 3.2% |
| S | 20710 | 3.1% |
| W | 19366 | 2.9% |
| D | 17800 | 2.7% |
| M | 15053 | 2.3% |
| X | 14595 | 2.2% |
| Other values (17) | 90698 | 13.7% |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 10452 | |
| s | 6115 | |
| u | 5500 | 9.4% |
| i | 3486 | 5.9% |
| d | 3392 | 5.8% |
| b | 3268 | 5.6% |
| h | 3158 | 5.4% |
| f | 2890 | 4.9% |
| x | 2636 | 4.5% |
| m | 2610 | 4.4% |
| Other values (17) | 15164 |
Other Punctuation
| Value | Count | Frequency (%) |
| \ | 339001 | |
| / | 434 | 0.1% |
| . | 296 | 0.1% |
| # | 10 | < 0.1% |
| , | 8 | < 0.1% |
| @ | 7 | < 0.1% |
| : | 4 | < 0.1% |
| ? | 4 | < 0.1% |
| ! | 4 | < 0.1% |
| " | 4 | < 0.1% |
| Other values (3) | 9 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 93561 | |
| 0 | 92891 | |
| 4 | 79416 | |
| 3 | 57271 | |
| 2 | 47864 | |
| 6 | 45449 | |
| 5 | 44564 | |
| 9 | 37008 | 6.6% |
| 8 | 34037 | 6.0% |
| 7 | 32819 | 5.8% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 20 | |
| = | 2 | 9.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 147598 |
Space Separator
| Value | Count | Frequency (%) |
| 15594 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 3070 |
Format
| Value | Count | Frequency (%) |
| | 4 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 2 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 2 |
Control
| Value | Count | Frequency (%) |
| | 1 |
Other Symbol
| Value | Count | Frequency (%) |
| ✖ | 1 |
Nonspacing Mark
| Value | Count | Frequency (%) |
| ️ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1070955 | |
| Latin | 722649 | |
| Inherited | 1 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 339256 | |
| C | 54301 | 7.5% |
| R | 41488 | 5.7% |
| H | 29441 | 4.1% |
| U | 21270 | 2.9% |
| S | 20710 | 2.9% |
| W | 19366 | 2.7% |
| D | 17800 | 2.5% |
| M | 15053 | 2.1% |
| X | 14595 | 2.0% |
| Other values (44) | 149369 |
Common
| Value | Count | Frequency (%) |
| \ | 339001 | |
| - | 147598 | |
| 1 | 93561 | 8.7% |
| 0 | 92891 | 8.7% |
| 4 | 79416 | 7.4% |
| 3 | 57271 | 5.3% |
| 2 | 47864 | 4.5% |
| 6 | 45449 | 4.2% |
| 5 | 44564 | 4.2% |
| 9 | 37008 | 3.5% |
| Other values (23) | 86332 | 8.1% |
Inherited
| Value | Count | Frequency (%) |
| ️ | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1793596 | |
| None | 7 | < 0.1% |
| Dingbats | 1 | < 0.1% |
| VS | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 339256 | |
| \ | 339001 | |
| - | 147598 | 8.2% |
| 1 | 93561 | 5.2% |
| 0 | 92891 | 5.2% |
| 4 | 79416 | 4.4% |
| 3 | 57271 | 3.2% |
| C | 54301 | 3.0% |
| 2 | 47864 | 2.7% |
| 6 | 45449 | 2.5% |
| Other values (73) | 496988 |
None
| Value | Count | Frequency (%) |
| | 4 | |
| Ç | 2 | |
| ß | 1 | 14.3% |
Dingbats
| Value | Count | Frequency (%) |
| ✖ | 1 |
VS
| Value | Count | Frequency (%) |
| ️ | 1 |
discount_amount
Real number (ℝ)
ZEROS 
| Distinct | 28058 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 499.49278 |
| Minimum | -599.5 |
|---|---|
| Maximum | 90300 |
| Zeros | 376306 |
| Zeros (%) | 64.4% |
| Negative | 3 |
| Negative (%) | < 0.1% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | -599.5 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 160.5 |
| 95-th percentile | 2930 |
| Maximum | 90300 |
| Range | 90899.5 |
| Interquartile range (IQR) | 160.5 |
Descriptive statistics
| Standard deviation | 1506.943 |
|---|---|
| Coefficient of variation (CV) | 3.0169466 |
| Kurtosis | 117.5672 |
| Mean | 499.49278 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.8424543 |
| Sum | 2.9196551 × 108 |
| Variance | 2270877.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 376306 | |
| 1000 | 5426 | 0.9% |
| 2000 | 4143 | 0.7% |
| 500 | 3648 | 0.6% |
| 200 | 3496 | 0.6% |
| 3000 | 2361 | 0.4% |
| 7000 | 2289 | 0.4% |
| 1500 | 1625 | 0.3% |
| 4000 | 1429 | 0.2% |
| 2200 | 1409 | 0.2% |
| Other values (28048) | 182392 |
| Value | Count | Frequency (%) |
| -599.5 | 1 | < 0.1% |
| -2 | 2 | < 0.1% |
| 0 | 376306 | |
| 0.08 | 1 | < 0.1% |
| 0.1 | 6 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.15 | 36 | < 0.1% |
| 0.16 | 1 | < 0.1% |
| 0.19 | 1 | < 0.1% |
| 0.2 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 90300 | 2 | < 0.1% |
| 50355.25 | 5 | |
| 50127.75 | 5 | |
| 48205 | 1 | < 0.1% |
| 47500 | 4 | |
| 45000 | 1 | < 0.1% |
| 42498.75 | 1 | < 0.1% |
| 41885 | 1 | < 0.1% |
| 38075.07 | 8 | |
| 35609.39 | 1 | < 0.1% |
payment_method
Categorical
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| cod | |
|---|---|
| Payaxis | |
| Easypay | |
| jazzwallet | |
| easypay_voucher | |
| Other values (13) |
Length
| Max length | 17 |
|---|---|
| Median length | 16 |
| Mean length | 6.1900538 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3618235 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | cod |
|---|---|
| 2nd row | cod |
| 3rd row | cod |
| 4th row | cod |
| 5th row | cod |
Common Values
| Value | Count | Frequency (%) |
| cod | 271960 | |
| Payaxis | 97641 | 16.7% |
| Easypay | 82900 | 14.2% |
| jazzwallet | 35145 | 6.0% |
| easypay_voucher | 31176 | 5.3% |
| bankalfalah | 23065 | 3.9% |
| jazzvoucher | 15633 | 2.7% |
| Easypay_MA | 14028 | 2.4% |
| customercredit | 7555 | 1.3% |
| apg | 1758 | 0.3% |
| Other values (8) | 3663 | 0.6% |
Length
| Value | Count | Frequency (%) |
| cod | 271960 | |
| payaxis | 97641 | 16.7% |
| easypay | 82900 | 14.2% |
| jazzwallet | 35145 | 6.0% |
| easypay_voucher | 31176 | 5.3% |
| bankalfalah | 23065 | 3.9% |
| jazzvoucher | 15633 | 2.7% |
| easypay_ma | 14028 | 2.4% |
| customercredit | 7555 | 1.3% |
| apg | 1758 | 0.3% |
| Other values (8) | 3663 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 635647 | |
| y | 355187 | 9.8% |
| c | 337363 | 9.3% |
| o | 327913 | 9.1% |
| d | 282261 | 7.8% |
| s | 234824 | 6.5% |
| e | 132555 | 3.7% |
| p | 130764 | 3.6% |
| l | 118040 | 3.3% |
| i | 107930 | 3.0% |
| Other values (20) | 955751 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3350406 | |
| Uppercase Letter | 222625 | 6.2% |
| Connector Punctuation | 45204 | 1.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 635647 | |
| y | 355187 | |
| c | 337363 | |
| o | 327913 | |
| d | 282261 | |
| s | 234824 | 7.0% |
| e | 132555 | 4.0% |
| p | 130764 | 3.9% |
| l | 118040 | 3.5% |
| i | 107930 | 3.2% |
| Other values (15) | 687922 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 97641 | |
| E | 96928 | |
| M | 14028 | 6.3% |
| A | 14028 | 6.3% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 45204 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3573031 | |
| Common | 45204 | 1.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 635647 | |
| y | 355187 | 9.9% |
| c | 337363 | 9.4% |
| o | 327913 | 9.2% |
| d | 282261 | 7.9% |
| s | 234824 | 6.6% |
| e | 132555 | 3.7% |
| p | 130764 | 3.7% |
| l | 118040 | 3.3% |
| i | 107930 | 3.0% |
| Other values (19) | 910547 |
Common
| Value | Count | Frequency (%) |
| _ | 45204 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3618235 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 635647 | |
| y | 355187 | 9.8% |
| c | 337363 | 9.3% |
| o | 327913 | 9.1% |
| d | 282261 | 7.8% |
| s | 234824 | 6.5% |
| e | 132555 | 3.7% |
| p | 130764 | 3.6% |
| l | 118040 | 3.3% |
| i | 107930 | 3.0% |
| Other values (20) | 955751 |
Working Date
Date
| Distinct | 789 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| Minimum | 2016-07-01 00:00:00 |
|---|---|
| Maximum | 2018-08-28 00:00:00 |
BI Status
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| Net | |
|---|---|
| Gross | |
| Valid | |
| #REF! | 1 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.1987395 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2454264 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | #REF! |
|---|---|
| 2nd row | Gross |
| 3rd row | Gross |
| 4th row | Net |
| 5th row | Valid |
Common Values
| Value | Count | Frequency (%) |
| Net | 234178 | |
| Gross | 201454 | |
| Valid | 148891 | |
| #REF! | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| net | 234178 | |
| gross | 201454 | |
| valid | 148891 | |
| ref | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 402908 | |
| N | 234178 | |
| t | 234178 | |
| e | 234178 | |
| G | 201454 | |
| r | 201454 | |
| o | 201454 | |
| i | 148891 | 6.1% |
| d | 148891 | 6.1% |
| a | 148891 | 6.1% |
| Other values (7) | 297787 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1869736 | |
| Uppercase Letter | 584526 | 23.8% |
| Other Punctuation | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 402908 | |
| t | 234178 | |
| e | 234178 | |
| r | 201454 | |
| o | 201454 | |
| i | 148891 | 8.0% |
| d | 148891 | 8.0% |
| a | 148891 | 8.0% |
| l | 148891 | 8.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 234178 | |
| G | 201454 | |
| V | 148891 | |
| R | 1 | < 0.1% |
| E | 1 | < 0.1% |
| F | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| # | 1 | |
| ! | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2454262 | |
| Common | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 402908 | |
| N | 234178 | |
| t | 234178 | |
| e | 234178 | |
| G | 201454 | |
| r | 201454 | |
| o | 201454 | |
| i | 148891 | 6.1% |
| d | 148891 | 6.1% |
| a | 148891 | 6.1% |
| Other values (5) | 297785 |
Common
| Value | Count | Frequency (%) |
| # | 1 | |
| ! | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2454264 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 402908 | |
| N | 234178 | |
| t | 234178 | |
| e | 234178 | |
| G | 201454 | |
| r | 201454 | |
| o | 201454 | |
| i | 148891 | 6.1% |
| d | 148891 | 6.1% |
| a | 148891 | 6.1% |
| Other values (7) | 297787 |
MV
Text
| Distinct | 9720 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 4.1444731 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2422544 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2233 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 1,950 |
|---|---|
| 2nd row | 240 |
| 3rd row | 2,450 |
| 4th row | 360 |
| 5th row | 1,110 |
| Value | Count | Frequency (%) |
| 999 | 9516 | 1.6% |
| 699 | 7801 | 1.3% |
| 499 | 7157 | 1.2% |
| 1,000 | 6895 | 1.2% |
| 399 | 6506 | 1.1% |
| 299 | 5997 | 1.0% |
| 599 | 5721 | 1.0% |
| 799 | 5715 | 1.0% |
| 2,000 | 4499 | 0.8% |
| 899 | 4353 | 0.7% |
| Other values (9710) | 520364 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 414466 | |
| 9 | 399121 | |
| , | 289367 | |
| 1 | 247310 | |
| 5 | 220128 | |
| 2 | 188243 | |
| 4 | 151901 | 6.3% |
| 3 | 146616 | 6.1% |
| 8 | 128646 | 5.3% |
| 6 | 117186 | 4.8% |
| Other values (3) | 119560 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2122017 | |
| Other Punctuation | 289367 | 11.9% |
| Space Separator | 8928 | 0.4% |
| Dash Punctuation | 2232 | 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 414466 | |
| 9 | 399121 | |
| 1 | 247310 | |
| 5 | 220128 | |
| 2 | 188243 | |
| 4 | 151901 | 7.2% |
| 3 | 146616 | 6.9% |
| 8 | 128646 | 6.1% |
| 6 | 117186 | 5.5% |
| 7 | 108400 | 5.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 289367 |
Space Separator
| Value | Count | Frequency (%) |
| 8928 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2232 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2422544 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 414466 | |
| 9 | 399121 | |
| , | 289367 | |
| 1 | 247310 | |
| 5 | 220128 | |
| 2 | 188243 | |
| 4 | 151901 | 6.3% |
| 3 | 146616 | 6.1% |
| 8 | 128646 | 5.3% |
| 6 | 117186 | 4.8% |
| Other values (3) | 119560 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2422544 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 414466 | |
| 9 | 399121 | |
| , | 289367 | |
| 1 | 247310 | |
| 5 | 220128 | |
| 2 | 188243 | |
| 4 | 151901 | 6.3% |
| 3 | 146616 | 6.1% |
| 8 | 128646 | 5.3% |
| 6 | 117186 | 4.8% |
| Other values (3) | 119560 | 4.9% |
Year
Categorical
HIGH CORRELATION 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| 2017 | |
|---|---|
| 2018 | |
| 2016 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2338096 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2016 |
|---|---|
| 2nd row | 2016 |
| 3rd row | 2016 |
| 4th row | 2016 |
| 5th row | 2016 |
Common Values
| Value | Count | Frequency (%) |
| 2017 | 290920 | |
| 2018 | 159695 | |
| 2016 | 133909 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2017 | 290920 | |
| 2018 | 159695 | |
| 2016 | 133909 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 584524 | |
| 0 | 584524 | |
| 1 | 584524 | |
| 7 | 290920 | |
| 8 | 159695 | 6.8% |
| 6 | 133909 | 5.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2338096 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 584524 | |
| 0 | 584524 | |
| 1 | 584524 | |
| 7 | 290920 | |
| 8 | 159695 | 6.8% |
| 6 | 133909 | 5.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2338096 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 584524 | |
| 0 | 584524 | |
| 1 | 584524 | |
| 7 | 290920 | |
| 8 | 159695 | 6.8% |
| 6 | 133909 | 5.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2338096 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 584524 | |
| 0 | 584524 | |
| 1 | 584524 | |
| 7 | 290920 | |
| 8 | 159695 | 6.8% |
| 6 | 133909 | 5.7% |
Month
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.1676544 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| median | 7 |
| Q3 | 11 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.4863048 |
|---|---|
| Coefficient of variation (CV) | 0.4863941 |
| Kurtosis | -1.3726432 |
| Mean | 7.1676544 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.1929145 |
| Sum | 4189666 |
| Variance | 12.154321 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 155456 | |
| 5 | 62603 | |
| 3 | 61489 | 10.5% |
| 8 | 48514 | 8.3% |
| 7 | 39151 | 6.7% |
| 2 | 38777 | 6.6% |
| 6 | 34530 | 5.9% |
| 4 | 34091 | 5.8% |
| 10 | 30623 | 5.2% |
| 12 | 29199 | 5.0% |
| Other values (2) | 50091 | 8.6% |
| Value | Count | Frequency (%) |
| 1 | 26067 | |
| 2 | 38777 | |
| 3 | 61489 | |
| 4 | 34091 | |
| 5 | 62603 | |
| 6 | 34530 | |
| 7 | 39151 | |
| 8 | 48514 | |
| 9 | 24024 | 4.1% |
| 10 | 30623 |
| Value | Count | Frequency (%) |
| 12 | 29199 | 5.0% |
| 11 | 155456 | |
| 10 | 30623 | 5.2% |
| 9 | 24024 | 4.1% |
| 8 | 48514 | 8.3% |
| 7 | 39151 | 6.7% |
| 6 | 34530 | 5.9% |
| 5 | 62603 | |
| 4 | 34091 | 5.8% |
| 3 | 61489 | 10.5% |
Customer Since
Date
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11 |
| Missing (%) | < 0.1% |
| Memory size | 4.5 MiB |
| Minimum | 2016-07-01 00:00:00 |
|---|---|
| Maximum | 2018-08-01 00:00:00 |
M-Y
Categorical
HIGH CORRELATION 
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| Nov-17 | |
|---|---|
| Nov-16 | |
| Mar-18 | |
| May-17 | |
| May-18 | 27867 |
| Other values (21) |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 3507144 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jul-16 |
|---|---|
| 2nd row | Jul-16 |
| 3rd row | Jul-16 |
| 4th row | Jul-16 |
| 5th row | Jul-16 |
Common Values
| Value | Count | Frequency (%) |
| Nov-17 | 83928 | 14.4% |
| Nov-16 | 71528 | 12.2% |
| Mar-18 | 41955 | 7.2% |
| May-17 | 34736 | 5.9% |
| May-18 | 27867 | 4.8% |
| Feb-18 | 26916 | 4.6% |
| Aug-17 | 25083 | 4.3% |
| Apr-17 | 21678 | 3.7% |
| Jun-17 | 19793 | 3.4% |
| Mar-17 | 19534 | 3.3% |
| Other values (16) | 211506 |
Length
| Value | Count | Frequency (%) |
| nov-17 | 83928 | 14.4% |
| nov-16 | 71528 | 12.2% |
| mar-18 | 41955 | 7.2% |
| may-17 | 34736 | 5.9% |
| may-18 | 27867 | 4.8% |
| feb-18 | 26916 | 4.6% |
| aug-17 | 25083 | 4.3% |
| apr-17 | 21678 | 3.7% |
| jun-17 | 19793 | 3.4% |
| mar-17 | 19534 | 3.3% |
| Other values (16) | 211506 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 584524 | |
| 1 | 584524 | |
| 7 | 290920 | 8.3% |
| 8 | 159695 | 4.6% |
| N | 155456 | 4.4% |
| o | 155456 | 4.4% |
| v | 155456 | 4.4% |
| a | 150159 | 4.3% |
| 6 | 133909 | 3.8% |
| M | 124092 | 3.5% |
| Other values (17) | 1012953 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1169048 | |
| Lowercase Letter | 1169048 | |
| Dash Punctuation | 584524 | |
| Uppercase Letter | 584524 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 155456 | |
| v | 155456 | |
| a | 150159 | |
| u | 122195 | |
| r | 95580 | |
| e | 92000 | |
| y | 62603 | 5.4% |
| n | 60597 | 5.2% |
| c | 59822 | 5.1% |
| p | 58115 | 5.0% |
| Other values (4) | 157065 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 155456 | |
| M | 124092 | |
| J | 99748 | |
| A | 82605 | |
| F | 38777 | 6.6% |
| O | 30623 | 5.2% |
| D | 29199 | 5.0% |
| S | 24024 | 4.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 584524 | |
| 7 | 290920 | |
| 8 | 159695 | 13.7% |
| 6 | 133909 | 11.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 584524 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1753572 | |
| Latin | 1753572 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 155456 | 8.9% |
| o | 155456 | 8.9% |
| v | 155456 | 8.9% |
| a | 150159 | 8.6% |
| M | 124092 | 7.1% |
| u | 122195 | 7.0% |
| J | 99748 | 5.7% |
| r | 95580 | 5.5% |
| e | 92000 | 5.2% |
| A | 82605 | 4.7% |
| Other values (12) | 520825 |
Common
| Value | Count | Frequency (%) |
| - | 584524 | |
| 1 | 584524 | |
| 7 | 290920 | |
| 8 | 159695 | 9.1% |
| 6 | 133909 | 7.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3507144 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 584524 | |
| 1 | 584524 | |
| 7 | 290920 | 8.3% |
| 8 | 159695 | 4.6% |
| N | 155456 | 4.4% |
| o | 155456 | 4.4% |
| v | 155456 | 4.4% |
| a | 150159 | 4.3% |
| 6 | 133909 | 3.8% |
| M | 124092 | 3.5% |
| Other values (17) | 1012953 |
FY
Categorical
HIGH CORRELATION 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| FY18 | |
|---|---|
| FY17 | |
| FY19 | 22935 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2338096 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FY17 |
|---|---|
| 2nd row | FY17 |
| 3rd row | FY17 |
| 4th row | FY17 |
| 5th row | FY17 |
Common Values
| Value | Count | Frequency (%) |
| FY18 | 306883 | |
| FY17 | 254706 | |
| FY19 | 22935 | 3.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| fy18 | 306883 | |
| fy17 | 254706 | |
| fy19 | 22935 | 3.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 584524 | |
| Y | 584524 | |
| 1 | 584524 | |
| 8 | 306883 | |
| 7 | 254706 | |
| 9 | 22935 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1169048 | |
| Decimal Number | 1169048 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 584524 | |
| 8 | 306883 | |
| 7 | 254706 | |
| 9 | 22935 | 2.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 584524 | |
| Y | 584524 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1169048 | |
| Common | 1169048 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 584524 | |
| 8 | 306883 | |
| 7 | 254706 | |
| 9 | 22935 | 2.0% |
Latin
| Value | Count | Frequency (%) |
| F | 584524 | |
| Y | 584524 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2338096 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 584524 | |
| Y | 584524 | |
| 1 | 584524 | |
| 8 | 306883 | |
| 7 | 254706 | |
| 9 | 22935 | 1.0% |
Customer ID
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 115326 |
|---|---|
| Distinct (%) | 19.7% |
| Missing | 11 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45790.512 |
| Minimum | 1 |
|---|---|
| Maximum | 115326 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 548 |
| Q1 | 13516 |
| median | 42856 |
| Q3 | 73536 |
| 95-th percentile | 107029 |
| Maximum | 115326 |
| Range | 115325 |
| Interquartile range (IQR) | 60020 |
Descriptive statistics
| Standard deviation | 34414.962 |
|---|---|
| Coefficient of variation (CV) | 0.75157409 |
| Kurtosis | -1.1258359 |
| Mean | 45790.512 |
| Median Absolute Deviation (MAD) | 29897 |
| Skewness | 0.32626641 |
| Sum | 2.676515 × 1010 |
| Variance | 1.1843896 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 85775 | 2524 | 0.4% |
| 163 | 2349 | 0.4% |
| 35 | 1877 | 0.3% |
| 33 | 1397 | 0.2% |
| 31025 | 1369 | 0.2% |
| 806 | 1310 | 0.2% |
| 1404 | 1269 | 0.2% |
| 767 | 1234 | 0.2% |
| 820 | 1190 | 0.2% |
| 58 | 1182 | 0.2% |
| Other values (115316) | 568812 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 2 | < 0.1% |
| 3 | 5 | < 0.1% |
| 4 | 428 | |
| 5 | 1 | < 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 115326 | 1 | < 0.1% |
| 115325 | 2 | |
| 115324 | 1 | < 0.1% |
| 115323 | 1 | < 0.1% |
| 115322 | 2 | |
| 115321 | 1 | < 0.1% |
| 115320 | 3 | |
| 115319 | 3 | |
| 115318 | 1 | < 0.1% |
| 115317 | 1 | < 0.1% |
| item_id | price | qty_ordered | grand_total | discount_amount | Month | Customer ID | status | category_name_1 | payment_method | BI Status | Year | M-Y | FY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| item_id | 1.000 | 0.179 | 0.169 | 0.293 | 0.143 | -0.275 | 0.767 | 0.153 | 0.194 | 0.289 | 0.213 | 0.927 | 0.891 | 0.778 |
| price | 0.179 | 1.000 | -0.163 | 0.730 | 0.282 | -0.057 | 0.221 | 0.028 | 0.045 | 0.070 | 0.039 | 0.052 | 0.054 | 0.067 |
| qty_ordered | 0.169 | -0.163 | 1.000 | 0.058 | -0.049 | -0.158 | 0.126 | 0.001 | 0.005 | 0.006 | 0.002 | 0.003 | 0.011 | 0.002 |
| grand_total | 0.293 | 0.730 | 0.058 | 1.000 | 0.247 | -0.113 | 0.277 | 0.000 | 0.004 | 0.012 | 0.001 | 0.003 | 0.016 | 0.003 |
| discount_amount | 0.143 | 0.282 | -0.049 | 0.247 | 1.000 | 0.057 | 0.099 | 0.016 | 0.047 | 0.066 | 0.020 | 0.009 | 0.038 | 0.021 |
| Month | -0.275 | -0.057 | -0.158 | -0.113 | 0.057 | 1.000 | -0.206 | 0.111 | 0.168 | 0.176 | 0.155 | 0.486 | 1.000 | 0.369 |
| Customer ID | 0.767 | 0.221 | 0.126 | 0.277 | 0.099 | -0.206 | 1.000 | 0.105 | 0.209 | 0.222 | 0.154 | 0.673 | 0.559 | 0.574 |
| status | 0.153 | 0.028 | 0.001 | 0.000 | 0.016 | 0.111 | 0.105 | 1.000 | 0.083 | 0.154 | 0.816 | 0.225 | 0.131 | 0.216 |
| category_name_1 | 0.194 | 0.045 | 0.005 | 0.004 | 0.047 | 0.168 | 0.209 | 0.083 | 1.000 | 0.135 | 0.160 | 0.272 | 0.184 | 0.199 |
| payment_method | 0.289 | 0.070 | 0.006 | 0.012 | 0.066 | 0.176 | 0.222 | 0.154 | 0.135 | 1.000 | 0.330 | 0.359 | 0.243 | 0.410 |
| BI Status | 0.213 | 0.039 | 0.002 | 0.001 | 0.020 | 0.155 | 0.154 | 0.816 | 0.160 | 0.330 | 1.000 | 0.180 | 0.224 | 0.167 |
| Year | 0.927 | 0.052 | 0.003 | 0.003 | 0.009 | 0.486 | 0.673 | 0.225 | 0.272 | 0.359 | 0.180 | 1.000 | 1.000 | 0.535 |
| M-Y | 0.891 | 0.054 | 0.011 | 0.016 | 0.038 | 1.000 | 0.559 | 0.131 | 0.184 | 0.243 | 0.224 | 1.000 | 1.000 | 1.000 |
| FY | 0.778 | 0.067 | 0.002 | 0.003 | 0.021 | 0.369 | 0.574 | 0.216 | 0.199 | 0.410 | 0.167 | 0.535 | 1.000 | 1.000 |
| item_id | status | created_at | sku | price | qty_ordered | grand_total | increment_id | category_name_1 | sales_commission_code | discount_amount | payment_method | Working Date | BI Status | MV | Year | Month | Customer Since | M-Y | FY | Customer ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 211131 | complete | 2016-07-01 | kreations_YI 06-L | 1950.0 | 1 | 1950.0 | 100147443 | Women's Fashion | \N | 0.0 | cod | 07-01-16 | #REF! | 1,950 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 1.0 |
| 1 | 211133 | canceled | 2016-07-01 | kcc_Buy 2 Frey Air Freshener & Get 1 Kasual Body Spray Free | 240.0 | 1 | 240.0 | 100147444 | Beauty & Grooming | \N | 0.0 | cod | 07-01-16 | Gross | 240 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 2.0 |
| 2 | 211134 | canceled | 2016-07-01 | Ego_UP0017-999-MR0 | 2450.0 | 1 | 2450.0 | 100147445 | Women's Fashion | \N | 0.0 | cod | 07-01-16 | Gross | 2,450 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 3.0 |
| 3 | 211135 | complete | 2016-07-01 | kcc_krone deal | 360.0 | 1 | 60.0 | 100147446 | Beauty & Grooming | R-FSD-52352 | 300.0 | cod | 07-01-16 | Net | 360 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 4.0 |
| 4 | 211136 | order_refunded | 2016-07-01 | BK7010400AG | 555.0 | 2 | 1110.0 | 100147447 | Soghaat | \N | 0.0 | cod | 07-01-16 | Valid | 1,110 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 5.0 |
| 5 | 211137 | canceled | 2016-07-01 | UK_Namkino All In One 200 Gms | 80.0 | 1 | 80.0 | 100147448 | Soghaat | \N | 0.0 | cod | 07-01-16 | Gross | 80 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 6.0 |
| 6 | 211138 | complete | 2016-07-01 | kcc_krone deal | 360.0 | 1 | 60.0 | 100147449 | Beauty & Grooming | \N | 300.0 | cod | 07-01-16 | Net | 360 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 7.0 |
| 7 | 211139 | complete | 2016-07-01 | UK_Namkino Mix Nimco 400 Gms | 170.0 | 1 | 170.0 | 100147450 | Soghaat | \N | 0.0 | cod | 07-01-16 | Net | 170 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 6.0 |
| 8 | 211140 | canceled | 2016-07-01 | Apple iPhone 6S 64GB | 96499.0 | 1 | 96499.0 | 100147451 | Mobiles & Tablets | \N | 0.0 | ublcreditcard | 07-01-16 | Gross | 96,499 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 8.0 |
| 9 | 211141 | canceled | 2016-07-01 | Apple iPhone 6S 64GB | 96499.0 | 1 | 96499.0 | 100147452 | Mobiles & Tablets | \N | 0.0 | mygateway | 07-01-16 | Gross | 96,499 | 2016 | 7 | 2016-07-01 | Jul-16 | FY17 | 8.0 |
| item_id | status | created_at | sku | price | qty_ordered | grand_total | increment_id | category_name_1 | sales_commission_code | discount_amount | payment_method | Working Date | BI Status | MV | Year | Month | Customer Since | M-Y | FY | Customer ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 584514 | 905196 | paid | 2018-08-28 | MEFGUL5A9F882AA5B99-36 | 1299.0 | 1 | 0.0 | 100562381 | Men's Fashion | NaN | 0.0 | customercredit | 8/28/2018 | Valid | 1,299 | 2018 | 8 | 2018-06-01 | Aug-18 | FY19 | 111132.0 |
| 584515 | 905198 | paid | 2018-08-28 | MEFPAK5B360B03C6B72 | 999.0 | 1 | 0.0 | 100562381 | Men's Fashion | NaN | 0.0 | customercredit | 8/28/2018 | Valid | 999 | 2018 | 8 | 2018-06-01 | Aug-18 | FY19 | 111132.0 |
| 584516 | 905199 | pending | 2018-08-28 | MATINF59BAB39FDBEF1 | 6760.0 | 2 | 13770.0 | 100562382 | Mobiles & Tablets | NaN | 0.0 | jazzvoucher | 8/28/2018 | Gross | 13,520 | 2018 | 8 | 2016-09-01 | Aug-18 | FY19 | 8123.0 |
| 584517 | 905200 | cod | 2018-08-28 | WOFVAL59D5EA84167F9-M | 400.0 | 1 | 550.0 | 100562383 | Women's Fashion | NaN | 0.0 | cod | 8/28/2018 | Valid | 400 | 2018 | 8 | 2018-08-01 | Aug-18 | FY19 | 115325.0 |
| 584518 | 905202 | cod | 2018-08-28 | WOFNIG5B4D7EB0E9FDD-L | 499.0 | 1 | 649.0 | 100562384 | Women's Fashion | NaN | 0.0 | cod | 8/28/2018 | Valid | 499 | 2018 | 8 | 2018-08-01 | Aug-18 | FY19 | 115325.0 |
| 584519 | 905204 | cod | 2018-08-28 | WOFSCE5AE00357AECDE | 699.0 | 1 | 849.0 | 100562385 | Women's Fashion | NaN | 0.0 | cod | 8/28/2018 | Valid | 699 | 2018 | 8 | 2018-08-01 | Aug-18 | FY19 | 115320.0 |
| 584520 | 905205 | processing | 2018-08-28 | MATHUA5AF70A7D1E50A | 35599.0 | 1 | 35899.0 | 100562386 | Mobiles & Tablets | NaN | 0.0 | bankalfalah | 8/28/2018 | Gross | 35,599 | 2018 | 8 | 2018-08-01 | Aug-18 | FY19 | 115326.0 |
| 584521 | 905206 | processing | 2018-08-28 | MATSAM5B6D7208C6D30 | 129999.0 | 2 | 652178.0 | 100562387 | Mobiles & Tablets | NaN | 0.0 | bankalfalah | 8/28/2018 | Gross | 259,998 | 2018 | 8 | 2018-07-01 | Aug-18 | FY19 | 113474.0 |
| 584522 | 905207 | processing | 2018-08-28 | MATSAM5B1509B4696EA | 87300.0 | 2 | 652178.0 | 100562387 | Mobiles & Tablets | NaN | 0.0 | bankalfalah | 8/28/2018 | Gross | 174,600 | 2018 | 8 | 2018-07-01 | Aug-18 | FY19 | 113474.0 |
| 584523 | 905208 | processing | 2018-08-28 | MATSAM5B10F91A9B6AB | 108640.0 | 2 | 652178.0 | 100562387 | Mobiles & Tablets | NaN | 0.0 | bankalfalah | 8/28/2018 | Gross | 217,280 | 2018 | 8 | 2018-07-01 | Aug-18 | FY19 | 113474.0 |